SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563413 LIMIT 1 [ RunTime:0.000296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563413 [ RunTime:0.001455s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (743639,364847,373670,105941,984737,879163,660067,719898,233221,370556,616896,911258,659611,915350,933808,339580,770190,928230,277471,303344,242909,818257,532204,699863,507945,1014254,556620,178120,343572,387538,143880,843763,146504,140391,7569,4800,344462,796875,588443,393223,500465,838491,189375,48544,376156,699542,573374,116767,538557,904926,107142,1879,990969,555303,431106,1012511,458348,188945,613818,369762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001408s ]