SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981988 LIMIT 1 [ RunTime:0.001673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981988 [ RunTime:0.003064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130341,121185,544277,538909,294420,481329,929152,313858,58234,518983,593564,298392,63991,227022,568612,406032,352027,1024731,167710,573371,960555,481322,952506,657676,596295,966788,705728,819561,435755,368477,154688,662938,236384,15035,319095,270019,566410,1031479,569854,927637,438922,1024228,515004,567799,121285,59655,918468,494077,121900,67855,131911,260161,694545,835350,246371,159451,818556,195391,613265,982653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]