SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314700 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314700 [ RunTime:0.001686s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (296231,449938,461563,293568,709951,210376,300317,153740,241796,1021715,172426,8151,484139,278650,606935,1019792,838198,191354,935620,713922,164771,300803,195990,28697,733521,582533,376041,592802,316833,109555,1034371,911962,593505,664493,406259,43847,798873,574712,488653,157483,399354,994530,741199,164027,306816,222816,114720,887417,264712,23322,136431,636010,247898,284748,443900,272336,1037657,728246,773713,475685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314700 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314700 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]