SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002816s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1038840 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1038840 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (919509,418904,600398,414999,727111,919360,628539,1039209,807221,467741,216113,677297,750964,980670,1023485,616290,388224,339253,611658,660592,8656,963460,750113,219514,754955,89511,396062,548790,157803,414555,168669,43871,27736,853923,731699,168268,714244,212048,749228,1042117,139164,513335,128849,272616,525850,393439,744870,352398,755996,766019,136763,166564,527741,437375,18879,426347,805883,278782,556749,135988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1038840 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1038840 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]