SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 485413 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 485413 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441650,46931,615066,61481,236999,341642,488648,645872,382466,535872,338774,815005,475123,326253,32613,935570,302375,79041,768538,237833,630313,830491,91323,968156,1037678,743433,943120,690636,626129,105951,751750,1030203,110042,60825,624923,474890,160076,1043821,758653,975567,324235,1045992,320741,693304,506828,1038932,393206,126865,668410,31433,13291,317721,316281,798280,921881,69132,208856,812537,188283,931748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 485413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 485413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]