SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480218 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480218 [ RunTime:0.001823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643146,224335,964324,369290,459660,519764,68886,691073,102936,949254,560734,39561,550849,520353,925042,948046,926706,736679,415139,369144,970853,885212,1036391,358607,790948,811908,383414,79057,534228,120619,3875,159670,443113,485246,92009,693859,454670,558955,547652,444047,351755,402901,775806,423307,544540,422173,931031,829111,166282,381277,308020,421561,442829,1031625,326787,351586,516223,403784,466250,9934) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001843s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000384s ]