SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 960412 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 960412 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631880,230565,27998,971499,889927,600144,949936,351983,874802,33428,620322,400580,424447,134251,5353,711373,53167,250440,18269,519647,553749,770712,653517,1047813,917765,344516,561103,577537,224697,853380,475573,1035905,960582,646819,894372,720620,615531,901080,305036,138552,1010855,997732,303726,305365,407823,367787,795529,831893,206953,675800,122934,838447,855714,478868,467943,867926,565860,982632,318860,843671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 960412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 960412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]