SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002007s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442929 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442929 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (96449,392253,424079,839060,561417,797940,758419,711994,978016,695780,167072,876201,587036,563812,70503,114782,220569,294842,202796,423844,973911,224320,510726,672750,814472,617694,473041,969381,722887,723812,200751,825191,116569,788034,577703,1024435,666965,950421,373613,554261,717590,277384,113700,299178,827349,378214,38119,76137,536394,145094,830184,895259,18936,517131,158618,276017,43845,254977,647879,909414) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442929 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442929 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]