SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001471s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400539 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400539 [ RunTime:0.003406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (621384,24722,907912,934318,571855,640499,818371,600985,806356,574796,476263,52087,411798,272873,481371,1004078,358600,262973,667309,734168,501133,355766,89107,686643,452012,837109,415564,301330,464683,424513,602411,1020219,718892,610626,323640,800536,1008514,418623,619041,654515,920573,439175,17762,441776,644237,510543,541981,706413,1030557,964782,350177,724936,430669,96294,149138,188293,543628,633417,350253,555960) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002702s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]