SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201212 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201212 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (597606,724624,666419,730456,703146,701280,272028,360572,349466,212349,652920,144417,715292,221304,473885,1002183,699911,235996,834662,740992,527958,709498,638474,61605,388215,963883,275859,686958,285031,767505,811402,842463,942149,625689,39756,155320,945812,272910,98991,504858,714553,138406,947444,614317,21467,931159,484743,585238,239256,612301,156207,49257,63550,839873,80532,101580,673263,563753,734807,346537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]