SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504886 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504886 [ RunTime:0.001386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997102,758652,980342,191406,186870,967480,860384,491107,375909,238003,935662,654783,401525,256279,883151,613218,510371,35161,124637,694203,427164,134150,730810,846437,291728,904363,1000794,484658,668089,402506,484637,225454,279446,770531,556269,460607,298903,569983,246688,66091,943131,139509,179433,786931,606092,39341,60270,765383,321339,976029,589376,247892,44439,781478,358267,360013,572079,816534,674731,299582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504886 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504886 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]