SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041977 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041977 [ RunTime:0.002718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (48492,32409,701866,757146,507675,127456,947417,171661,500255,832144,152077,678229,76816,411708,65916,631934,620399,237715,149736,643314,633775,69696,1008701,1044208,134446,270871,755934,926128,1018440,119282,118494,714323,995809,960385,320084,608388,619102,125729,827590,671157,268141,438029,979766,88139,888963,242056,700949,141248,560917,991062,268020,217065,414515,94824,14767,1027460,1016869,839450,539612,407832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041977 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041977 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]