SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047876 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047876 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286283,525902,794478,933280,869585,853967,808447,134504,856223,593914,232352,190852,482505,776745,528975,194649,847128,196843,666759,477635,613081,927832,313299,298927,888577,88934,509066,44261,365633,975905,945983,1044507,99476,174584,766712,137636,220921,59664,525111,521342,763074,387501,151620,393051,458005,300479,806234,634960,300119,574996,1035463,212917,508994,836846,182626,667945,402155,998009,337147,398353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]