SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 136200 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 136200 [ RunTime:0.003545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362283,172305,100627,708380,1038671,1003619,242568,438456,728638,529569,885083,316965,701193,315614,292456,14382,607069,658380,160522,221773,266152,490057,79681,340143,207553,77022,241118,671722,910202,458209,117963,220424,113438,844075,725404,461735,524467,470589,603178,717338,581238,113543,863841,667360,194290,676266,581657,28655,451473,280559,990780,200082,260984,614385,230989,907712,495943,1032878,398645,758308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 136200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 136200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]