SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422993 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422993 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (390209,786642,777417,950783,377565,234944,12940,481664,849780,895702,180321,478259,309269,363268,718051,321633,12427,926565,939443,1024514,236725,655857,877222,821210,407417,72730,281923,427163,286941,17309,831079,557957,486555,582910,831025,183645,790251,49775,125383,830939,9233,245243,928756,943279,323285,265742,618522,546053,228791,86951,121540,910053,355267,711536,175405,585199,94112,656236,830202,295122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001256s ]