SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001859s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 476830 LIMIT 1 [ RunTime:0.000514s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 476830 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (183001,822592,298823,312320,674885,685536,133107,1017756,226973,110551,226901,538397,1016460,385309,975588,35692,518221,135668,795829,153601,663096,744466,342224,104558,338937,401640,266854,997129,674854,424431,674803,358405,639092,125243,533832,250589,631771,504616,352689,319755,238066,654047,419804,126,939371,886033,49368,71991,537213,931752,1022902,220596,332987,483423,422511,500583,793511,533603,731996,65782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 476830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 476830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]