SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402512 LIMIT 1 [ RunTime:0.001375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402512 [ RunTime:0.002484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151652,717681,431753,758258,16567,853081,948431,648938,183566,655572,1002996,909964,765495,985645,832668,671304,432937,557225,998899,260261,505056,582892,649836,615287,120176,870069,963969,482957,108037,60496,451177,730419,390740,1047895,377372,1023665,543232,427347,886744,161178,432444,22453,53600,161679,894864,946970,408481,38352,530190,984940,78696,604491,559644,1034111,127303,949458,373397,703579,857195,759479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002528s ]