SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481984 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481984 [ RunTime:0.003172s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411383,89884,687882,779781,919268,362066,214618,764214,643540,662353,761060,657871,286998,404390,24565,32745,45664,562663,779115,424832,26396,890027,693051,755289,315389,698684,101049,359311,401664,802074,393539,534550,674472,69152,232137,531734,885945,795971,432415,15354,845717,518515,693278,174975,528876,898887,564706,965184,379243,413981,1019066,792097,439449,668696,1000100,785399,216076,898982,720137,415653) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481984 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481984 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]