SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 169813 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 169813 [ RunTime:0.001752s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868418,298124,166696,219715,8920,599356,1048734,463375,55055,662537,867773,671579,819318,172403,688841,920931,739293,705128,206303,496724,57524,53421,143470,831224,558337,156626,910108,189859,676773,964383,834779,744354,847932,290444,455186,558964,101770,122171,564058,766437,979337,231255,738820,409732,242044,280945,103185,852535,688047,664769,811648,373753,939036,567721,889619,950889,382141,847259,877807,515171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 169813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 169813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]