SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 722510 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 722510 [ RunTime:0.003170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708710,801766,616187,285230,566370,619038,349736,955354,1001876,944744,784175,558678,986786,44177,17456,65412,515719,75926,815194,406876,761226,488466,367346,589322,54701,116320,917974,834941,126090,1001411,877160,15536,400951,1025278,878451,964663,168126,63678,767359,365854,793418,675481,666694,553225,987796,137599,479469,886571,273624,279211,394444,843516,642845,902223,128179,718503,989045,841011,348288,729786) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 722510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 722510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000649s ]