SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541525 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541525 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117300,589427,122716,113852,751822,256928,242838,914226,901895,507771,827741,676267,230276,893917,902396,685197,99729,245213,174684,497767,205003,259831,365519,579684,190775,189524,954684,868507,407596,520851,60052,416877,468650,411253,177739,268584,801040,943385,657824,951009,299119,46593,146823,1004611,432647,586213,259248,554293,503285,239738,249794,442011,109546,542172,173656,960840,465041,300201,687584,1029271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]