SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45569 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45569 [ RunTime:0.001669s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792522,113378,471818,823262,871143,641322,568236,952101,437348,142294,602750,988607,615895,458565,102752,811513,809138,6849,481820,298464,871962,693311,772050,960587,813728,254493,666518,356962,1021445,23914,82554,936442,521818,187660,29408,233147,959237,301412,878821,810732,68881,986355,83196,314908,759248,79252,197649,955040,346493,964349,290092,118248,881744,1017044,345486,99527,764873,235243,961385,355102) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]