SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 260020 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 260020 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455442,351851,300665,64590,184249,857729,709121,15308,507943,468580,153109,883833,146562,456963,703142,533636,891675,454614,70013,577042,364999,849766,170280,527116,337664,337186,515968,561623,31703,489683,722337,710173,481383,708780,466470,227406,990034,990408,606013,388292,33270,1042588,635360,644497,552234,809148,161230,822632,274286,663779,140601,351531,377193,956314,449250,616779,19888,418951,165953,401479) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 260020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 260020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]