SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002262s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293418 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293418 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (443971,1041293,758927,895839,736439,69742,973727,769286,576491,868542,201283,378042,556437,362089,268666,920615,628486,307268,294288,888546,927657,2356,580751,573386,44034,852821,727285,206667,622220,460762,324300,1011645,96291,15596,210143,667310,933929,339945,817275,727944,257079,47905,310482,29231,198555,71226,992404,277395,831724,964515,110037,391487,202292,997960,22975,626031,582063,401969,120422,876340) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]