SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569410 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569410 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (571020,916528,759682,274815,733596,496764,118277,77549,477282,582317,93172,477366,341754,808754,73343,229594,530174,1045515,856413,766064,870089,795938,571117,818384,25035,689033,310171,1006288,223445,87401,615186,133114,1039606,641683,485584,68073,516237,532196,388848,365667,86808,986734,1025183,949105,380517,37317,741338,392050,882435,790089,465811,738847,808962,185547,943554,892514,712862,129893,504007,154072) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000460s ]