SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 441022 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 441022 [ RunTime:0.002460s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807725,379873,732555,987391,980060,614699,533060,571978,127305,480103,205822,447455,538552,152674,977035,494219,48871,316335,32434,266138,150219,238962,154381,481029,555824,451903,159875,1026903,698123,485802,749383,836490,571148,315936,1018859,237269,198078,267648,190494,679717,1000779,203170,743804,464612,556512,874194,458775,931413,142775,269705,923977,389446,491473,964539,935889,745719,570976,1015052,263508,185925) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 441022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 441022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000485s ]