SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505420 LIMIT 1 [ RunTime:0.004892s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505420 [ RunTime:0.009037s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (499849,226644,497980,492626,101104,935914,437202,67148,569606,855442,34524,83571,664551,359890,384707,653695,130993,841131,959571,747129,437636,744501,530681,200899,935258,264712,119706,65231,499432,1016964,586106,818957,257369,542172,589841,68348,911564,400503,714981,437733,471426,277078,565890,495115,811176,748226,176883,838695,533556,468964,91921,724107,673030,1034128,114437,836852,239617,1025671,664590,535480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002010s ]