SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414378 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414378 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044003,312811,91553,80304,77266,39067,596116,681080,183503,854487,693818,864495,512466,215756,1046826,989753,935619,163240,149674,578782,1042026,980046,273920,419974,621549,659399,494787,273895,998672,282602,266368,961859,567571,740847,927343,441644,833670,523071,985587,336138,344107,283281,451480,927821,118756,449294,598239,17626,666356,887483,828225,1016806,593790,867313,342214,902607,731528,1010413,572053,443898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]