SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036222 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036222 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (160844,530872,399669,422832,1038147,565664,900135,76900,752869,481951,730158,307447,741201,773850,158330,61606,801972,966122,305176,980050,370075,492259,661174,616925,379660,612002,305569,940621,704571,401130,90437,1019258,952823,879612,460080,349922,441921,533306,678723,267241,617025,409917,350757,838937,10895,834193,183754,860754,181736,638330,16972,677554,619099,845512,484269,488850,363993,764999,907207,716488) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]