SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540522 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540522 [ RunTime:0.003797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35362,361923,58807,317244,297221,329258,740789,924551,813781,184283,724620,900772,282447,771712,61429,70813,109925,48126,350161,588692,606052,99494,650216,165653,269722,565806,672991,160221,450141,545472,876508,157828,364899,533282,100844,430975,447385,912248,28620,1046047,749269,242738,659354,385711,211989,991866,915809,497822,997731,485120,610047,3884,13132,26173,988575,969100,1014494,553805,846530,971860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]