SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002350s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542841 LIMIT 1 [ RunTime:0.000950s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542841 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (422962,1047364,273829,168625,119280,399076,461432,104975,257405,417052,793070,53614,128250,831226,347765,861350,455019,73969,434157,616091,788386,900721,723022,293209,908093,712811,469794,336334,390560,988315,325803,15061,144692,442909,33698,775718,218753,922721,858495,1017089,882751,821458,880287,689993,580595,746507,792086,628314,506664,907903,944206,748991,199041,337751,623843,717868,99526,286052,996788,683635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]