SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103441 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103441 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316941,409735,206135,2830,591067,771336,367358,233503,418845,809121,736741,842845,686528,374112,655962,915200,29222,317256,563685,1044213,116018,387307,140892,749413,902478,465317,114610,211426,484207,666814,814116,559939,648264,848347,364091,526625,989842,814028,171371,201129,198686,328798,1045350,386403,814113,683698,400426,6656,130388,308137,459013,67101,996179,497920,497771,1019645,61547,122265,815639,376763) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000874s ]