SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438011 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438011 [ RunTime:0.001479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859855,974336,402885,380818,379418,111214,35687,898707,727912,624006,817537,1048085,213301,268466,669087,509211,922372,1027943,747343,399602,1008131,57419,673349,73190,878819,587124,927154,251502,477843,795682,469385,164136,160881,479575,166815,419999,223672,92582,543703,128361,978114,195902,260307,641213,806177,1034474,650121,514106,331609,417919,77472,700836,84125,373256,1048076,211097,77650,592558,398845,168090) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]