SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 173928 LIMIT 1 [ RunTime:0.001326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 173928 [ RunTime:0.002848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523518,1036693,687892,560902,87523,564324,523135,683178,408263,995183,201093,73737,69674,875549,320176,340532,488001,288929,64490,219864,425065,719950,831412,541030,781587,180702,300700,749338,656989,137693,710277,347744,1028144,723137,981240,120396,276902,701636,873076,815487,983166,735238,481063,253456,315478,236755,104335,148879,636855,728907,47819,543001,24062,645791,874825,122989,237216,968474,1012899,562491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 173928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 173928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001073s ]