SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039476 LIMIT 1 [ RunTime:0.000742s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039476 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549236,270342,940439,877214,838093,783023,702431,716993,553303,554765,984856,708544,424979,312649,147283,860802,641862,1029463,700879,959678,426466,49358,252421,849430,844980,592694,807248,721878,56486,349561,203998,522867,893780,486207,443311,220246,960891,258173,162379,1027445,653317,423237,75933,905463,893899,138900,881885,477098,485449,834954,488615,953472,482119,101709,1019407,579235,103364,90294,393148,930463) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]