SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570748 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570748 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (217592,93814,3257,2380,378957,1005972,992658,158724,619335,64166,21886,874984,483152,113086,176913,86248,596849,887407,866205,680340,393272,190862,468231,341463,852286,216219,795655,88102,39451,729602,1002576,656981,644350,81204,1036555,193273,535963,57122,547302,379411,195279,194276,907291,99076,168527,684570,694338,26076,615196,9388,290826,85090,507315,276313,1001995,372386,819644,649814,261156,285458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003930s ]