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` = 556184 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 556184 [ RunTime:0.002954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620897,818444,21858,854992,435541,685291,383907,1001975,1018646,601002,587666,671892,861112,121833,679740,517140,264447,433133,999186,377859,273159,579787,908193,553609,691561,806244,586700,1033615,469245,80595,269281,139962,615889,53640,134814,519771,1006665,80320,579228,632964,1003921,510463,498165,812094,577559,83518,870640,213010,994955,448685,191241,59212,741003,282334,1013645,904779,432184,119758,701567,202562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 556184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 556184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001549s ]