SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047957 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047957 [ RunTime:0.002000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993266,1014131,21592,728005,194347,534754,562327,85856,970755,360098,696381,898647,799259,94450,255057,968642,405802,475574,447142,468935,448227,212157,757633,1005940,565555,661549,279176,180385,1046280,87058,188530,264002,703021,222870,866415,189859,770404,593312,629887,778469,1011146,145185,434167,55437,86221,526040,1025200,292178,1000418,360194,406555,664972,795387,606247,384357,400502,1010120,457839,243454,156441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021748s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047957 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047957 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]