SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029851 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029851 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605407,909613,643203,744388,771455,230952,326587,797954,863338,651004,368521,1033469,553707,570209,366916,206390,737061,576891,1034386,723837,229188,747854,1035660,904560,476325,358145,634458,357037,549438,701690,887042,858061,580175,485005,551109,682199,144802,426505,107301,575469,1010733,96961,496966,971614,485525,552744,994063,623442,389408,330073,860175,168243,290047,789274,471258,870262,312524,264894,339430,807849) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000954s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]