SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50450 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50450 [ RunTime:0.001710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833509,365384,521734,264015,737949,385660,458505,163937,589978,767139,704247,561375,284559,125204,249361,336728,137911,441173,922799,433441,820698,173768,62628,472293,35019,189108,756492,724151,792803,271209,435687,90215,230579,639841,1037430,681710,926105,45973,1003191,607901,362215,938326,1018837,910999,683065,650780,98395,187410,527483,763362,17568,820604,959950,207700,40830,458638,688624,966058,328653,627852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]