SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508458 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508458 [ RunTime:0.001484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (476530,579147,870834,334756,290199,741088,613250,234474,699508,281460,593756,183724,514236,110742,491478,91867,950319,768292,301712,169632,686481,620534,1009834,716223,614830,945562,1037841,351257,355909,523909,926992,272221,1031684,224983,938522,449879,872306,301426,792821,228209,181745,724884,384769,276010,564137,657548,784800,658338,807152,995059,836664,941124,785823,741160,658223,254803,735094,687358,467878,41210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]