SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526120 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526120 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18152,924901,722703,932562,34111,193509,236982,910501,791476,732826,281079,543903,648757,692467,643066,978947,974555,31005,185997,262932,462945,943229,629405,879392,640202,250708,654985,713327,653260,490013,104262,55518,162503,485905,750954,161291,574030,391175,305060,953211,547282,543018,827092,116700,88590,410543,1023796,642652,802726,382249,20749,888888,750825,283987,586242,449528,457719,447741,20216,660088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]