SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435396 LIMIT 1 [ RunTime:0.000562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435396 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766932,510876,507274,1046953,576832,972214,428019,447328,889385,255219,1001828,865160,750731,305490,648854,16639,551703,271064,393840,1004916,659872,426346,530506,765808,730848,1012075,286835,877489,690076,226219,269685,92740,292784,1009348,1038006,403566,559650,1002009,618644,356185,81195,27025,268066,141367,636992,370202,923878,673616,1047769,395251,1021096,663028,138099,854135,859963,735434,926230,929594,981980,226350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003081s ]