SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506116 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506116 [ RunTime:0.003408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270393,29731,958096,1013623,928254,709655,296054,57446,476109,462581,462278,643684,807240,154389,850989,838637,716553,910788,386355,115918,934043,822246,398760,49244,830177,831650,26831,970772,71939,695316,920591,267135,495192,285318,146935,633139,413331,144822,583838,953799,151976,855685,26050,620581,409664,415799,808014,977432,468005,536289,163076,999919,123192,854367,323696,739172,287445,365715,838701,555954) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]