SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249144 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249144 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (167814,750667,221512,296080,726940,363220,672866,358543,4613,112749,208634,331660,442037,274030,95105,311402,910992,419356,423496,59018,470531,244071,608290,691697,798413,942207,617937,429194,442009,875654,791269,830740,376627,207175,362444,182346,1768,364508,3446,668428,878962,990115,885728,521973,408785,318396,264474,283423,746688,903787,401233,486621,951592,27702,1019708,905991,812484,824022,338049,1003124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]