SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466513 LIMIT 1 [ RunTime:0.002229s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466513 [ RunTime:0.008552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1030313,641468,861352,6462,959729,752580,286232,644877,466011,343746,208715,365410,240778,423259,657315,942037,196199,568683,280982,613972,942107,654627,595518,135021,678181,664250,916795,988391,992999,1030728,846525,872017,187352,641057,561379,913917,35359,202384,533574,652741,504948,304356,698958,290830,842135,934177,932968,520516,193288,819717,147533,428849,677304,511323,692285,1042009,526490,1046121,6694,435977) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000826s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001645s ]