SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001476s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385303 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385303 [ RunTime:0.002564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261181,39362,925384,98690,496796,323276,392837,210015,408932,959964,201540,692081,1030526,297270,982514,581392,517313,10607,695423,685860,336760,502186,559668,592255,862544,841837,454644,156008,970277,175928,825849,672741,376071,667882,877847,26467,579135,66663,862079,505690,833661,147805,102511,401068,367803,990046,15466,656340,608529,592063,238247,492953,498992,463126,346084,323656,121878,851596,58646,849752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000577s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]