SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 939208 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 939208 [ RunTime:0.006000s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (800790,558600,595706,420983,1021127,500754,173689,207630,365723,738002,305807,914104,563655,793532,675248,13715,834737,130169,639565,489074,755620,698113,106148,1041584,528938,40657,105723,803740,843998,331561,618349,447201,553669,812606,318066,425052,201050,919334,598270,841021,90312,297816,758601,304527,372321,36612,244744,928497,939542,905933,302730,793558,256932,810407,66153,159353,396154,23818,845819,1016096) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 939208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 939208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]