SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505111 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505111 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404163,827707,520987,106938,528232,972608,728097,122995,365647,129196,1001966,47168,747309,418275,758325,566654,588118,903441,729723,988172,538258,465926,99305,13369,238735,98632,100209,486457,622398,242603,878514,504919,527798,876423,47099,114150,556607,620891,107871,817831,1017358,842160,216293,334666,684299,1026462,596757,777429,107203,287028,203660,73649,38982,134834,1021453,513509,206031,12907,199565,646347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]