SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 274017 LIMIT 1 [ RunTime:0.004274s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 274017 [ RunTime:0.003415s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1019354,961934,454538,907484,1041228,427561,262635,533757,287458,432090,147265,203539,755753,25338,572270,491062,596646,235846,1014138,37327,395535,1002564,473797,201599,413500,838816,802425,264170,574593,287470,520014,516454,310923,101027,1037291,742597,571849,567348,1044938,340844,774363,1009853,72891,231430,154649,208587,12680,926624,481080,500495,84446,679796,866828,676075,208468,559395,160886,606746,773195,612756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 274017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 274017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]