SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504364 LIMIT 1 [ RunTime:0.000469s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504364 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293546,325158,153474,993007,116446,188799,407763,473002,576005,795005,900440,660233,300480,766379,242765,518237,482712,922478,864829,98526,167072,333243,978982,993235,54133,561510,62633,142350,1774,821011,331688,223178,1039961,405126,391725,285740,1010997,615085,145902,339514,413330,377758,966348,60891,545716,9738,469316,272842,472312,138238,760540,10711,26241,291767,676695,50338,926011,514140,344225,236741) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002233s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504364 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504364 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001526s ]