SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414303 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414303 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20434,64910,293230,961205,640982,453269,796365,744404,248100,1045900,959032,900304,278804,71250,770836,926497,254805,900533,249643,1028782,438420,206117,244126,147698,307781,1046518,175456,74671,35913,281033,381508,879228,506220,630058,63575,187963,291668,718514,326936,956615,275083,473158,54027,38071,339847,999541,899929,900601,420343,711926,193425,1000943,954323,24118,1006426,257971,227948,90397,76227,596369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]