SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 129200 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 129200 [ RunTime:0.002064s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502649,816446,101981,280363,448229,412304,807777,732575,744020,101044,971979,648271,604040,1019919,643294,685564,9109,849320,760366,729638,851768,349463,1026024,637542,642671,360623,580120,241240,999911,514789,171573,33493,326619,113803,157170,702614,319023,387011,467350,41287,671245,949272,510516,83682,704599,225420,753875,637832,76744,468436,869279,971212,297166,733475,1032631,268782,784914,385244,967924,286166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 129200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 129200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]