SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 236648 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 236648 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (319203,107494,536176,175365,627950,1025919,324274,680209,374347,992104,161646,450405,689192,759921,273299,338559,391173,171073,849720,754666,904904,698069,1045991,644213,458110,777775,204559,282885,613138,1002265,408752,263750,361129,261700,470900,519846,668607,593754,346379,488379,260331,779437,612145,429268,989316,838410,576614,438406,477410,850369,345843,437089,290804,286963,656940,745386,898520,581817,293985,608272) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 236648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 236648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]