SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299713 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299713 [ RunTime:0.003312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (488867,3778,327327,247558,1035821,611866,43522,147873,849678,501253,348100,95638,491720,425058,279771,392184,925999,663727,215407,133531,175382,1048318,99348,138581,795419,756857,979761,471759,492765,398265,44746,90471,766302,393486,212952,61332,929157,259855,448313,585470,689458,117736,503578,475527,226688,124909,178779,945069,16705,809543,80484,699462,707247,31232,697177,116164,151813,50657,787175,119293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]