SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316413 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316413 [ RunTime:0.002517s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430258,12211,571312,513782,871508,292801,4324,734968,867010,569575,659235,479842,99860,818147,1030050,393713,48705,465136,893663,313909,805717,625785,16768,423545,1017398,228840,630377,36190,406721,47057,310404,133862,515231,824510,208058,532418,147862,109330,699868,29069,698476,379225,368508,796784,986839,806081,350740,320511,458549,142666,259911,384645,472379,49858,614866,904006,1036833,999457,451256,689229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000905s ]