SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8029 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8029 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609575,272477,503394,515291,142894,1031803,287973,238943,753532,774919,663467,607075,669603,903060,453169,58457,457897,956892,319870,730189,328104,899512,991768,150082,717331,606058,323713,203530,612005,707288,165678,42649,449270,740260,118840,747918,45998,219215,974100,90171,874208,325626,687719,539987,880748,722667,90777,1005270,680981,498332,634317,867056,561850,623123,718425,588150,687660,34114,164383,298818) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]