SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002457s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403418 LIMIT 1 [ RunTime:0.006778s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403418 [ RunTime:0.008976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (295902,651352,706409,132747,892482,1016201,287237,248701,655227,686641,906193,999548,85852,53384,72119,844854,511603,401946,799595,391735,807037,1031000,857246,280359,274743,920161,732063,44573,470895,42577,185907,1016079,30203,74786,45455,263508,380500,47433,979152,902141,849291,420865,774884,365244,770190,1001295,661337,893761,338769,705836,488041,187021,823087,225168,43814,66498,80400,290725,469052,515871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001053s ]