SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407008 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407008 [ RunTime:0.002052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155708,219822,617727,72691,60847,75124,419788,503720,613116,431967,99887,814121,199460,673857,838075,687517,334355,430225,281411,354343,78876,531100,839715,797693,446700,614311,364672,501116,406482,550678,44336,868357,709803,654523,177726,371520,236245,83649,447358,508896,566697,188453,2908,12948,387880,680804,52226,702075,845832,518245,289108,221584,664294,333435,935834,689909,1002951,373349,1033757,308541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]