SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261611 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261611 [ RunTime:0.001442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311857,24309,955937,510557,993223,831136,290829,598972,800563,871767,207775,925900,636926,957591,591935,600169,142170,134239,998981,540317,625624,501950,822587,254834,341662,314931,862298,580696,198177,620972,201659,413541,313708,697552,765432,882906,515703,38606,638538,569900,687905,289214,629820,629983,445276,290200,374275,360993,732616,667342,541064,189052,1005763,868467,981523,330991,621081,394164,996042,943549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]