SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445846 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445846 [ RunTime:0.001754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (21084,12269,236321,388221,28312,414351,383039,172918,633999,494682,1017310,534958,403521,940587,373013,940893,572877,136743,822823,634331,371605,830383,620180,940086,509276,765101,898422,751967,216417,468141,795030,853147,111296,957594,489563,457280,416029,601839,764503,342828,568400,724241,810758,147642,788695,189311,361687,461541,722796,742747,662793,317231,678793,309534,468080,948345,139078,602192,478080,231593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445846 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445846 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000998s ]