SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981308 LIMIT 1 [ RunTime:0.001627s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981308 [ RunTime:0.002310s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524765,997634,103650,371976,1045360,616106,857466,735681,120660,259415,147482,688247,5763,1027090,428215,353165,455880,948752,939741,910056,424749,580863,3356,1015153,6135,319036,826159,704082,344393,162100,904070,379991,5366,5391,857760,502970,561584,238165,683171,936357,639916,460643,198761,104113,307161,880512,483258,48336,926334,125071,624950,951166,558214,504225,889696,174855,424221,926863,717696,475545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]