SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002040s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 921046 LIMIT 1 [ RunTime:0.001029s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 921046 [ RunTime:0.004545s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856761,820117,322912,964173,608238,395632,131753,499410,122603,19865,166583,754741,389888,224414,7663,821762,664434,83517,963118,992000,805474,450161,474494,267366,108013,824843,1030529,464334,483075,680612,246315,629018,253244,1030586,772386,697363,793540,686727,120543,719463,690328,467587,881353,568565,994880,241923,868725,596796,846017,267873,755252,139037,490164,1026537,486608,42411,630637,513176,181115,898119) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 921046 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 921046 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]