SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193405 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193405 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355641,403443,483968,1034761,908517,221923,624271,325642,835792,77686,906895,65937,806258,981264,7860,828021,112077,749966,901806,260061,443386,895024,281495,826520,42670,332673,860519,230235,246715,831714,614330,382831,955348,253612,21595,987857,927587,228333,1017050,949951,225988,349072,463151,206253,132142,603971,391841,754893,461448,95150,454606,82341,109002,38316,836898,710560,99099,201413,575863,369810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000407s ]