SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006218 LIMIT 1 [ RunTime:0.001005s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006218 [ RunTime:0.005990s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (577220,694239,80347,844654,338521,484128,779797,150116,590131,358937,673573,422640,926937,429604,715614,126282,455612,267094,675395,610213,47589,806988,940843,998698,805527,848728,656698,738053,1040507,946829,1023406,877795,276750,575565,323078,315958,638533,468454,183382,1004441,168489,715487,747928,100111,335204,577264,1035291,870786,579467,411858,984685,733960,753284,221661,686013,230412,171059,1040924,899712,587541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000455s ]