SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005461s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51909 LIMIT 1 [ RunTime:0.006216s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51909 [ RunTime:0.005214s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (947846,227655,970317,131962,377941,610112,641154,787203,845135,236439,1036140,705274,472043,2766,974955,1043911,693134,424051,456642,109422,764566,235408,363443,809122,269274,751583,793296,688227,902653,10445,653021,998522,847599,1012713,288500,184177,187589,479518,341202,599210,826130,455247,341685,551621,146750,821872,808794,579057,924979,1023971,289078,968234,128954,633781,122291,140613,725605,732819,648660,891040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005366s ]