SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 920302 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 920302 [ RunTime:0.002273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904690,36594,462991,55198,407216,496962,609186,134282,332574,904098,12043,652103,1025136,975204,982797,655511,14591,108019,415854,332644,948464,380347,329369,828076,470766,779224,712425,249170,660813,34372,439432,713993,158577,894637,258098,327996,726969,115209,25275,439197,585586,315570,817605,410983,930186,604494,44356,539974,570643,95230,409337,356800,778458,789889,150602,297378,840628,930074,12560,929615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 920302 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 920302 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]